/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * amdin.java
 *
 * Created on Nov 8, 2011, 11:29:06 AM
 */
package GUI;

import BLL.Loaisanpham;
import BLL.B_Nhanvien;
import BLL.B_thuchi;
import BLL.sanpham;
import BLL.Tienluong;
import DBH.DBHelper;
import java.awt.Dimension;
import java.beans.PropertyVetoException;
import java.beans.Statement;
import java.io.File;
import java.io.InputStream;
import java.net.URISyntaxException;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;
import java.lang.Double;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.ImageIcon;
import javax.swing.JDialog;
import javax.swing.JFileChooser;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.UIManager;
import javax.swing.table.DefaultTableModel;

/**
 *
 * @author Huy
 */
public class Admin1 extends javax.swing.JFrame {

    DBHelper obj = new DBHelper();
    B_Nhanvien b;
    Loaisanpham c;
    sanpham d;
    B_thuchi e;
    Tienluong f;
    Vector v;
    DefaultTableModel model1;
    DefaultTableModel model2;
    DefaultTableModel model3;
    DefaultTableModel model4;
    DefaultTableModel model5;
    String usr;
    String pwd1;

    /** Creates new form amdin */
    public Admin1(String name, String pas) {
        this.usr = name;
        this.pwd1 = pas;
//                        try {
//         UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
//        } catch (Exception ex) {
//        System.err.println(ex.getMessage());
//        }
        initComponents();
        model1 = (DefaultTableModel) tableNhanvien.getModel();
        model2 = (DefaultTableModel) tableMh.getModel();
        model3 = (DefaultTableModel) tableLoaihang.getModel();
        model5 = (DefaultTableModel) tableThuchi.getModel();
        model4 = (DefaultTableModel) tableChucvu.getModel();
        jPanel1.setVisible(false);
        jPanel2.setVisible(false);
        jDesktopPane1.add(new ImagePanel(new ImageIcon("IMG\\8.jpg").getImage()));
        jDesktopPane1.setSize(new Dimension(800, 600));
        jDesktopPane2.add(new ImagePanel(new ImageIcon("IMG\\8.jpg").getImage()));
        jDesktopPane3.add(new ImagePanel(new ImageIcon("IMG\\8.jpg").getImage()));
        jDesktopPane4.add(new ImagePanel(new ImageIcon("IMG\\8.jpg").getImage()));
        display1();
        displaylsp();
        displaysp();
        displaytc();
        displaycmb();
        displaytl();
    }

    // load du lieu bang nhan vien
    public void loadTable1(Vector v) {
        int k1 = model1.getRowCount();
        for (int j = 0; j < k1; j++) {
            if (model1.getRowCount() != 0) {
                model1.removeRow(0);
            }
        }
        for (int i = 0; i < v.size(); i++) {
            b = (B_Nhanvien) v.get(i);
            Vector k = new Vector();
            k.addElement(b.getIdnv());
            k.addElement(b.getTen());
            k.addElement(b.getDiachi());
            k.addElement(b.getSodienthoai());
            k.addElement(b.getMatkhau());
            k.addElement(b.getChucvu());
            k.addElement(b.getNgayvao());
            model1.addRow(k);

        }
        tableNhanvien.setModel(model1);
    }

    // load du lieu bang loai san pham
    public void loadTablelsp(Vector v) {
        int k1 = model3.getRowCount();
        for (int j = 0; j < k1; j++) {
            if (model3.getRowCount() != 0) {
                model3.removeRow(0);
            }
        }
        for (int i = 0; i < v.size(); i++) {
            c = (Loaisanpham) v.get(i);
            Vector k = new Vector();
            k.addElement(c.getIdloaisp());
            k.addElement(c.getTen());
            model3.addRow(k);

        }
        tableLoaihang.setModel(model3);
    }
    // load du lieu bang san pham

    // Load va hien du lieu vao cho loai san pham o muc san pham
    public void loadcmb(Vector v) {
        cmdLoai.removeAllItems();

        for (int i = 0; i < v.size(); i++) {
            c = (Loaisanpham) v.get(i);
            String s = c.getIdloaisp();
            cmdLoai.addItem(s);
        }
    }

    public void displaycmb() {
        c = new Loaisanpham();
        Vector v1 = new Vector();
        try {
            v1 = c.getAllloaisanpham();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        this.loadcmb(v1);
    }
    //

    public void loadTablesp(Vector v) {
        int k1 = model2.getRowCount();
        for (int j = 0; j < k1; j++) {
            if (model2.getRowCount() != 0) {
                model2.removeRow(0);
            }
        }
        for (int i = 0; i < v.size(); i++) {
            d = (sanpham) v.get(i);
            Vector k = new Vector();
            k.addElement(d.getIdsp());
            k.addElement(d.getTen());
            k.addElement(d.getGiatien());
            k.addElement(d.getSoluong());
            k.addElement(d.getLoai());
            model2.addRow(k);

        }
        tableMh.setModel(model2);
    }

    // hien bang nhan vien
    public void display1() {
        b = new B_Nhanvien();
        Vector v1 = new Vector();
        try {
            v1 = b.getAllnhanvien();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        this.loadTable1(v1);
    }
    // hien bang loai san pham

    public void displaylsp() {
        c = new Loaisanpham();
        Vector v1 = new Vector();
        try {
            v1 = c.getAllloaisanpham();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        this.loadTablelsp(v1);
    }
    // hien bang san pham

    public void displaysp() {
        d = new sanpham();
        Vector v1 = new Vector();
        try {
            v1 = d.getAllsanpham();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        this.loadTablesp(v1);
    }
    // hien bang nhan vien sau khi tim kiem

    public void display2(String ten) {
        b = new B_Nhanvien();
        Vector v2 = new Vector();
        try {
            v2 = b.getnhanvienName(ten);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        this.loadTable1(v2);
    }
    // hien bang loai san pham sau khi tim kiem

    public void displaylsp2(String ten) {
        c = new Loaisanpham();
        Vector v2 = new Vector();
        try {
            v2 = c.getloaispName(ten);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        this.loadTablelsp(v2);
    }
    // Hien bang san pham sau khi tiem kiem

    public void displaysp2(String ten) {
        d = new sanpham();
        Vector v2 = new Vector();
        try {
            v2 = d.search(ten);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        this.loadTablesp(v2);
    }
    ///// Thêm nhan vien

    public void add1() {
        b = new B_Nhanvien();
        b.setIdnv(txtIdnv.getText());
        b.setTen(txtTennv.getText());
        b.setDiachi(txtDiachinv.getText());
        b.setSodienthoai(txtSdtnv.getText());
        b.setMatkhau(txtMknv.getText());
        b.setChucvu(txtChucvunv.getText());
        String d1 = ((JTextField) DateNgayvaonv.getDateEditor().getUiComponent()).getText();
        b.setNgayvao(d1);
        Vector v = new Vector();
        v.add(txtIdnv.getText());
        v.add(txtTennv.getText());
        v.add(txtDiachinv.getText());
        v.add(txtSdtnv.getText());
        v.add(txtMknv.getText());
        v.add(txtChucvunv.getText());
        v.add(d1);
        int t = 0;
        try {
            t = b.Insertnhanvien(b);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        if (t == 1) {
            JOptionPane.showMessageDialog(this, "Add successful", "Infofrm", JOptionPane.INFORMATION_MESSAGE);
            model1.addRow(v);
        } else {
            JOptionPane.showMessageDialog(this, "Add erro!");
        }
    }
    // Them loai san pham

    public void addlsp() {
        c = new Loaisanpham();
        c.setIdloaisp(txtIdlh.getText());
        c.setTen(txttenlh.getText());
        Vector v = new Vector();
        v.add(txtIdlh.getText());
        v.add(txttenlh.getText());
        int t = 0;
        try {
            t = c.Insertloaisanpham(c);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        if (t == 1) {
            JOptionPane.showMessageDialog(this, "Add successful", "Infofrm", JOptionPane.INFORMATION_MESSAGE);
            model3.addRow(v);
        } else {
            JOptionPane.showMessageDialog(this, "Add erro!");
        }
    }
    // Them san pham

    public void addsp() {
        d = new sanpham();
        d.setIdsp(txtIdMh.getText());
        d.setTen(txtTenMh.getText());
        d.setGiatien(txtGiatienMh.getText());
        int slmh = Integer.parseInt(txtSlMh.getText());
        d.setSoluong(slmh);
        d.setLoai(cmdLoai.getSelectedItem().toString());
        Vector v = new Vector();
        v.add(txtIdMh.getText());
        v.add(txtTenMh.getText());
        v.add(txtGiatienMh.getText());
        v.add(slmh);
        v.add(cmdLoai.getSelectedItem().toString());
        int t = 0;
        try {
            t = d.insertSanpham(d);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        if (t == 1) {
            JOptionPane.showMessageDialog(this, "Add successful", "Infofrm", JOptionPane.INFORMATION_MESSAGE);
            model2.addRow(v);
        } else {
            JOptionPane.showMessageDialog(this, "Add erro!");
        }
    }
    // chinh sua nhan vien 

    public void upadte1() {
        b = new B_Nhanvien();
        b.setIdnv(txtIdnv.getText());
        b.setTen(txtTennv.getText());
        b.setDiachi(txtDiachinv.getText());
        b.setSodienthoai(txtSdtnv.getText());
        b.setMatkhau(txtMknv.getText());
        b.setChucvu(txtChucvunv.getText());
        String d1 = ((JTextField) DateNgayvaonv.getDateEditor().getUiComponent()).getText();
        b.setNgayvao(d1);
        Vector v = new Vector();
        v.add(txtIdnv.getText());
        v.add(txtTennv.getText());
        v.add(txtDiachinv.getText());
        v.add(txtSdtnv.getText());
        v.add(txtMknv.getText());
        v.add(txtChucvunv.getText());
        v.add(d1);
        int t = 0;
        try {
            t = b.Updatenhanien(b);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        if (t == 1) {
            JOptionPane.showMessageDialog(this, "Update successful", "Infofrm", JOptionPane.INFORMATION_MESSAGE);
            int i = tableNhanvien.getSelectedRow();
            model1.removeRow(i);
            model1.addRow(v);
        } else {
            JOptionPane.showMessageDialog(this, "Update erro!");
        }
    }
    // chinh sua loai san pham

    public void upadtelsp() {
        c = new Loaisanpham();
        c.setIdloaisp(txtIdlh.getText());
        c.setTen(txttenlh.getText());
        Vector v = new Vector();
        v.add(txtIdlh.getText());
        v.add(txttenlh.getText());
        int t = 0;
        try {
            t = c.Updateloaisanpham(c);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        if (t == 1) {
            JOptionPane.showMessageDialog(this, "Update successful", "Infofrm", JOptionPane.INFORMATION_MESSAGE);
            int i = tableLoaihang.getSelectedRow();
            model3.removeRow(i);
            model3.addRow(v);
        } else {
            JOptionPane.showMessageDialog(this, "Update erro!");
        }
    }
    // Chinh sua san pham

    public void upadtesp() {
        d = new sanpham();
        d.setIdsp(txtIdMh.getText());
        d.setTen(txtTenMh.getText());
        d.setGiatien(txtGiatienMh.getText());
        int slmh = Integer.parseInt(txtSlMh.getText());
        d.setSoluong(slmh);
        d.setLoai(cmdLoai.getSelectedItem().toString());
        Vector v = new Vector();
        v.add(txtIdMh.getText());
        v.add(txtTenMh.getText());
        v.add(txtGiatienMh.getText());
        v.add(slmh);
        v.add(cmdLoai.getSelectedItem().toString());
        int t = 0;
        try {
            t = d.updateSanpham(d);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        if (t == 1) {
            JOptionPane.showMessageDialog(this, "Update successful", "Infofrm", JOptionPane.INFORMATION_MESSAGE);
            int i = tableMh.getSelectedRow();
            model2.removeRow(i);
            model2.addRow(v);
        } else {
            JOptionPane.showMessageDialog(this, "Update erro!");
        }
    }
    // Xoa nhan vien

    public void delete1() {
        String idnv = txtIdnv.getText().toString();
        int t = 0;
        try {
            t = b.Deletenhanvien(idnv);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        if (t == 1) {
            JOptionPane.showMessageDialog(this, "delete successful", "Infofrm", JOptionPane.INFORMATION_MESSAGE);
            int i = tableNhanvien.getSelectedRow();
            model1.removeRow(i);
        } else {
            JOptionPane.showMessageDialog(this, "delete erro!");
        }
    }
    // Xoai loai san pham

    public void deletelsp() {
        String idnv = txtIdlh.getText().toString();
        int t = 0;
        try {
            t = c.Deleteloaisanpham(idnv);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        if (t == 1) {
            JOptionPane.showMessageDialog(this, "delete successful", "Infofrm", JOptionPane.INFORMATION_MESSAGE);
            int i = tableLoaihang.getSelectedRow();
            model3.removeRow(i);
        } else {
            JOptionPane.showMessageDialog(this, "delete erro!");
        }
    }
    // Xoa san pham

    public void deletesp() {
        String idnv = txtIdMh.getText().toString();
        int t = 0;
        try {
            t = d.deleteSanpham(idnv);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        if (t == 1) {
            JOptionPane.showMessageDialog(this, "delete successful", "Infofrm", JOptionPane.INFORMATION_MESSAGE);
            int i = tableMh.getSelectedRow();
            model2.removeRow(i);
        } else {
            JOptionPane.showMessageDialog(this, "delete erro!");
        }
    }
    // Tim kiem ten nhan vien

    public void seach1() {

        b = new B_Nhanvien();
        Vector v = new Vector();
        try {
            v = b.getnhanvienName(txtSearchnv.getText());
        } catch (SQLException e) {
            e.printStackTrace();
        }
        this.display2(txtSearchnv.getText());
    }
    // Tim kiem ten loai san pham

    public void seachlsp() {

        c = new Loaisanpham();
        Vector v = new Vector();
        try {
            v = c.getloaispName(txtSearchlh.getText());
        } catch (SQLException e) {
            e.printStackTrace();
        }
        this.displaylsp2(txtSearchlh.getText());
    }
    // Tim kiem  san pham

    public void seachsp() {

        d = new sanpham();
        Vector v = new Vector();
        try {
            v = d.search(txtSearchMh.getText());
        } catch (SQLException e) {
            e.printStackTrace();
        }
        this.displaysp2(txtSearchMh.getText());
    }

    /// Load dữ liệu cho bảng Thu Chi    
    public void loadTabletc(Vector v) {
        int k1 = model5.getRowCount();
        for (int j = 0; j < k1; j++) {
            if (model5.getRowCount() != 0) {
                model5.removeRow(0);
            }
        }
        for (int i = 0; i < v.size(); i++) {
            e = (B_thuchi) v.get(i);
            Vector k = new Vector();
            k.addElement(e.getNumber());
            k.addElement(e.getIdnv());
            k.addElement(e.getTongtien());
            model5.addRow(k);

        }
        tableThuchi.setModel(model5);
    }
    // Hiện bảng Thu Chi

    public void displaytc() {
        e = new B_thuchi();
        Vector v1 = new Vector();
        try {
            v1 = e.getAllthuchi();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        this.loadTabletc(v1);
    }
    
    // Load dữ liệu bảng Tiền Lương
     public void loadTabletl(Vector v) {
        int k1 = model4.getRowCount();
        for (int j = 0; j < k1; j++) {
            if (model4.getRowCount() != 0) {
                model4.removeRow(0);
            }
        }
        for (int i = 0; i < v.size(); i++) {
            f = (Tienluong) v.get(i);
            Vector k = new Vector();
            k.addElement(f.getChucvu());
            k.addElement(f.getLuong());
            model4.addRow(k);

        }
        tableChucvu.setModel(model4);
    }
    
    /// Hiện bảng tiền lương
     
        public void displaytl() {
        f = new Tienluong();
        Vector v1 = new Vector();
        try {
            v1 = f.getAlltienluong();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        this.loadTabletl(v1);
    }
    /// Thêm chức vụ
         public void addcv() {
        f = new Tienluong();
        f.setChucvu(txtChucvu.getText());
        f.setLuong(txtLuong.getText());
        Vector v = new Vector();
        v.add(txtChucvu.getText());
        v.add(txtLuong.getText());
        int t = 0;
        try {
            t = f.Inserttienluong(f);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        if (t == 1) {
            JOptionPane.showMessageDialog(this, "Add successful", "Infofrm", JOptionPane.INFORMATION_MESSAGE);
            model4.addRow(v);
        } else {
            JOptionPane.showMessageDialog(this, "Add erro!");
        }
    }
    /// Chỉnh sửa mức lương
             public void upadtetl() {
        f = new Tienluong();
        f.setChucvu(txtChucvu.getText());
        f.setLuong(txtLuong.getText());
        Vector v = new Vector();
         int i = tableLoaihang.getSelectedRow();
        v.add(txtChucvu.getText());
        v.add(txtLuong.getText());
        int t = 0;
        try {
            t = f.Updatetienluong(f);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        if (t == 1) {
            JOptionPane.showMessageDialog(this, "Update successful", "Infofrm", JOptionPane.INFORMATION_MESSAGE);
           
            this.displaytl();
        } else {
            JOptionPane.showMessageDialog(this, "Update erro!");
        }
    }
            //// Xoá Mức lương
             
 public void deletetl() {
        int i=tableChucvu.getSelectedRow();
        String idnv = tableChucvu.getValueAt(i, 0).toString();
        int t = 0;
        try {
            t = f.Deletetienluong(idnv);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        if (t == 1) {
            JOptionPane.showMessageDialog(this, "delete successful", "Infofrm", JOptionPane.INFORMATION_MESSAGE);
           
            model4.removeRow(i);
        } else {
            JOptionPane.showMessageDialog(this, "delete erro!");
        }
    }
 
 
 
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        jTabbedPane1 = new javax.swing.JTabbedPane();
        jPanel1 = new javax.swing.JPanel();
        jDesktopPane1 = new javax.swing.JDesktopPane();
        jLabel14 = new javax.swing.JLabel();
        txtSearchnv = new javax.swing.JTextField();
        jLabel4 = new javax.swing.JLabel();
        jScrollPane1 = new javax.swing.JScrollPane();
        tableNhanvien = new javax.swing.JTable();
        txtSdtnv = new javax.swing.JTextField();
        jLabel5 = new javax.swing.JLabel();
        btnDelnv = new javax.swing.JButton();
        txtIdnv = new javax.swing.JTextField();
        btnEditnv = new javax.swing.JButton();
        jLabel1 = new javax.swing.JLabel();
        btnBacknv = new javax.swing.JButton();
        jLabel6 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        txtMknv = new javax.swing.JTextField();
        txtDiachinv = new javax.swing.JTextField();
        btnLoadnv = new javax.swing.JButton();
        btnAddnv = new javax.swing.JButton();
        txtTennv = new javax.swing.JTextField();
        btnSearchnv = new javax.swing.JButton();
        jLabel2 = new javax.swing.JLabel();
        txtChucvunv = new javax.swing.JTextField();
        jLabel17 = new javax.swing.JLabel();
        DateNgayvaonv = new com.toedter.calendar.JDateChooser();
        btnInnv = new javax.swing.JButton();
        jPanel2 = new javax.swing.JPanel();
        jDesktopPane2 = new javax.swing.JDesktopPane();
        jLabel15 = new javax.swing.JLabel();
        txtIdlh = new javax.swing.JTextField();
        jLabel16 = new javax.swing.JLabel();
        btnDellh = new javax.swing.JButton();
        btnAddlh = new javax.swing.JButton();
        btnEditlh = new javax.swing.JButton();
        jLabel12 = new javax.swing.JLabel();
        btnSearchlh = new javax.swing.JButton();
        txtSearchlh = new javax.swing.JTextField();
        btnLoadlh = new javax.swing.JButton();
        txttenlh = new javax.swing.JTextField();
        jScrollPane3 = new javax.swing.JScrollPane();
        tableLoaihang = new javax.swing.JTable();
        jPanel3 = new javax.swing.JPanel();
        jPanel5 = new javax.swing.JPanel();
        jDesktopPane3 = new javax.swing.JDesktopPane();
        txtIdMh = new javax.swing.JTextField();
        jLabel10 = new javax.swing.JLabel();
        txtTenMh = new javax.swing.JTextField();
        jLabel8 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        txtGiatienMh = new javax.swing.JTextField();
        btnLoadMh = new javax.swing.JButton();
        btnEditMh = new javax.swing.JButton();
        btnAddMh = new javax.swing.JButton();
        txtSlMh = new javax.swing.JTextField();
        btnBackMh = new javax.swing.JButton();
        jLabel11 = new javax.swing.JLabel();
        btnDelMh = new javax.swing.JButton();
        btnSearchMh = new javax.swing.JButton();
        txtSearchMh = new javax.swing.JTextField();
        jScrollPane2 = new javax.swing.JScrollPane();
        tableMh = new javax.swing.JTable();
        jLabel13 = new javax.swing.JLabel();
        cmdLoai = new javax.swing.JComboBox();
        jLabel7 = new javax.swing.JLabel();
        jPanel4 = new javax.swing.JPanel();
        jDesktopPane4 = new javax.swing.JDesktopPane();
        jScrollPane5 = new javax.swing.JScrollPane();
        tableThuchi = new javax.swing.JTable();
        jLabel20 = new javax.swing.JLabel();
        txtChucvu = new javax.swing.JTextField();
        jLabel21 = new javax.swing.JLabel();
        txtLuong = new javax.swing.JTextField();
        jScrollPane4 = new javax.swing.JScrollPane();
        tableChucvu = new javax.swing.JTable();
        btnDelTl = new javax.swing.JButton();
        btnEditTl = new javax.swing.JButton();
        btnAddTl = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setTitle("Hệ thống chỉnh sửa ( Chỉ dành cho Admin )");
        setResizable(false);

        jTabbedPane1.setBackground(new java.awt.Color(255, 51, 51));
        jTabbedPane1.setForeground(new java.awt.Color(255, 0, 51));
        jTabbedPane1.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
        jTabbedPane1.setFont(new java.awt.Font("Times New Roman", 0, 12));
        jTabbedPane1.setName(""); // NOI18N

        jPanel1.setBackground(new java.awt.Color(204, 255, 204));
        jPanel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
        jPanel1.setForeground(new java.awt.Color(255, 0, 0));
        jPanel1.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

        jDesktopPane1.setBackground(new java.awt.Color(204, 255, 255));

        jLabel14.setFont(new java.awt.Font("Times New Roman", 0, 21));
        jLabel14.setForeground(new java.awt.Color(255, 0, 0));
        jLabel14.setText("Nhân Viên");
        jLabel14.setBounds(130, 0, 103, 70);
        jDesktopPane1.add(jLabel14, javax.swing.JLayeredPane.DEFAULT_LAYER);
        txtSearchnv.setBounds(560, 480, 120, 31);
        jDesktopPane1.add(txtSearchnv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel4.setFont(new java.awt.Font("Times New Roman", 0, 14));
        jLabel4.setForeground(new java.awt.Color(255, 0, 51));
        jLabel4.setText("Số điện thoại");
        jLabel4.setBounds(90, 200, 81, 17);
        jDesktopPane1.add(jLabel4, javax.swing.JLayeredPane.DEFAULT_LAYER);

        tableNhanvien.setFont(new java.awt.Font("Times New Roman", 0, 14));
        tableNhanvien.setForeground(new java.awt.Color(51, 0, 255));
        tableNhanvien.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "Idnv", "Tên", "Địa chỉ", "Số Đt", "Mật khẩu", "Chức vụ", "Ngày vào"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        tableNhanvien.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                tableNhanvienMouseClicked(evt);
            }
        });
        jScrollPane1.setViewportView(tableNhanvien);

        jScrollPane1.setBounds(460, 40, 730, 360);
        jDesktopPane1.add(jScrollPane1, javax.swing.JLayeredPane.DEFAULT_LAYER);

        txtSdtnv.setFont(new java.awt.Font("Times New Roman", 0, 14));
        txtSdtnv.setBounds(190, 200, 140, 23);
        jDesktopPane1.add(txtSdtnv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel5.setFont(new java.awt.Font("Times New Roman", 0, 14));
        jLabel5.setForeground(new java.awt.Color(255, 0, 51));
        jLabel5.setText("Mật khẩu");
        jLabel5.setBounds(90, 250, 71, 17);
        jDesktopPane1.add(jLabel5, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnDelnv.setBackground(new java.awt.Color(204, 0, 204));
        btnDelnv.setFont(new java.awt.Font("Times New Roman", 0, 14));
        btnDelnv.setForeground(new java.awt.Color(0, 0, 204));
        btnDelnv.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\delete_icon.png")); // NOI18N
        btnDelnv.setText("Xóa");
        btnDelnv.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnDelnvActionPerformed(evt);
            }
        });
        btnDelnv.setBounds(290, 470, 106, 48);
        jDesktopPane1.add(btnDelnv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        txtIdnv.setFont(new java.awt.Font("Times New Roman", 0, 14));
        txtIdnv.setBounds(190, 70, 140, 23);
        jDesktopPane1.add(txtIdnv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnEditnv.setBackground(new java.awt.Color(255, 255, 0));
        btnEditnv.setFont(new java.awt.Font("Times New Roman", 0, 14));
        btnEditnv.setForeground(new java.awt.Color(255, 0, 0));
        btnEditnv.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\icon_refresh.png")); // NOI18N
        btnEditnv.setText("Sửa");
        btnEditnv.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnEditnvActionPerformed(evt);
            }
        });
        btnEditnv.setBounds(160, 470, 106, 48);
        jDesktopPane1.add(btnEditnv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel1.setFont(new java.awt.Font("Times New Roman", 0, 14));
        jLabel1.setForeground(new java.awt.Color(255, 0, 51));
        jLabel1.setText("ID");
        jLabel1.setBounds(90, 80, 71, 17);
        jDesktopPane1.add(jLabel1, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnBacknv.setBackground(new java.awt.Color(0, 204, 153));
        btnBacknv.setFont(new java.awt.Font("Times New Roman", 0, 14));
        btnBacknv.setForeground(new java.awt.Color(255, 0, 0));
        btnBacknv.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\go-back.png")); // NOI18N
        btnBacknv.setText("Quay lại");
        btnBacknv.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnBacknvActionPerformed(evt);
            }
        });
        btnBacknv.setBounds(430, 470, 106, 48);
        jDesktopPane1.add(btnBacknv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel6.setFont(new java.awt.Font("Times New Roman", 0, 14));
        jLabel6.setForeground(new java.awt.Color(255, 0, 51));
        jLabel6.setText("Ngày vào");
        jLabel6.setBounds(90, 350, 71, 17);
        jDesktopPane1.add(jLabel6, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel3.setFont(new java.awt.Font("Times New Roman", 0, 14));
        jLabel3.setForeground(new java.awt.Color(255, 0, 51));
        jLabel3.setText("Địa chỉ");
        jLabel3.setBounds(90, 160, 71, 17);
        jDesktopPane1.add(jLabel3, javax.swing.JLayeredPane.DEFAULT_LAYER);

        txtMknv.setFont(new java.awt.Font("Times New Roman", 0, 14));
        txtMknv.setBounds(190, 250, 140, 23);
        jDesktopPane1.add(txtMknv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        txtDiachinv.setFont(new java.awt.Font("Times New Roman", 0, 14));
        txtDiachinv.setBounds(190, 160, 140, 23);
        jDesktopPane1.add(txtDiachinv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnLoadnv.setBackground(new java.awt.Color(204, 153, 255));
        btnLoadnv.setForeground(new java.awt.Color(204, 0, 0));
        btnLoadnv.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\001_44.png")); // NOI18N
        btnLoadnv.setText("Hiện lại danh sách");
        btnLoadnv.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnLoadnvActionPerformed(evt);
            }
        });
        btnLoadnv.setBounds(1020, 470, 160, 50);
        jDesktopPane1.add(btnLoadnv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnAddnv.setBackground(new java.awt.Color(102, 255, 51));
        btnAddnv.setFont(new java.awt.Font("Times New Roman", 0, 14));
        btnAddnv.setForeground(new java.awt.Color(255, 0, 0));
        btnAddnv.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\green-plus-sign-small.gif")); // NOI18N
        btnAddnv.setText("Thêm");
        btnAddnv.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnAddnvActionPerformed(evt);
            }
        });
        btnAddnv.setBounds(30, 470, 106, 48);
        jDesktopPane1.add(btnAddnv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        txtTennv.setFont(new java.awt.Font("Times New Roman", 0, 14));
        txtTennv.setBounds(190, 120, 140, 23);
        jDesktopPane1.add(txtTennv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnSearchnv.setBackground(new java.awt.Color(153, 255, 102));
        btnSearchnv.setForeground(new java.awt.Color(153, 0, 153));
        btnSearchnv.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\Update1.png")); // NOI18N
        btnSearchnv.setText("Tìm Nhân Viên");
        btnSearchnv.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnSearchnvActionPerformed(evt);
            }
        });
        btnSearchnv.setBounds(710, 470, 141, 50);
        jDesktopPane1.add(btnSearchnv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel2.setFont(new java.awt.Font("Times New Roman", 0, 14));
        jLabel2.setForeground(new java.awt.Color(255, 0, 51));
        jLabel2.setText("Ten");
        jLabel2.setBounds(90, 120, 71, 17);
        jDesktopPane1.add(jLabel2, javax.swing.JLayeredPane.DEFAULT_LAYER);

        txtChucvunv.setFont(new java.awt.Font("Times New Roman", 0, 14));
        txtChucvunv.setBounds(190, 300, 140, 23);
        jDesktopPane1.add(txtChucvunv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel17.setFont(new java.awt.Font("Times New Roman", 0, 14));
        jLabel17.setForeground(new java.awt.Color(255, 0, 51));
        jLabel17.setText("Chức vụ");
        jLabel17.setBounds(90, 300, 71, 17);
        jDesktopPane1.add(jLabel17, javax.swing.JLayeredPane.DEFAULT_LAYER);

        DateNgayvaonv.setDateFormatString("MM/dd/yyyy");
        DateNgayvaonv.setBounds(190, 340, 140, 40);
        jDesktopPane1.add(DateNgayvaonv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnInnv.setText("In DS NV");
        btnInnv.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnInnvActionPerformed(evt);
            }
        });
        btnInnv.setBounds(870, 470, 130, 50);
        jDesktopPane1.add(btnInnv, javax.swing.JLayeredPane.DEFAULT_LAYER);

        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jDesktopPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 1212, Short.MAX_VALUE)
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jDesktopPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 542, Short.MAX_VALUE)
        );

        jTabbedPane1.addTab("Edit Nhân Viên", new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\Copy of sss.png"), jPanel1); // NOI18N

        jPanel2.setBackground(new java.awt.Color(255, 204, 255));
        jPanel2.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
        jPanel2.setForeground(new java.awt.Color(51, 255, 0));

        jLabel15.setFont(new java.awt.Font("Times New Roman", 0, 14));
        jLabel15.setForeground(new java.awt.Color(0, 0, 255));
        jLabel15.setText("ID");
        jLabel15.setBounds(140, 210, 71, 17);
        jDesktopPane2.add(jLabel15, javax.swing.JLayeredPane.DEFAULT_LAYER);

        txtIdlh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        txtIdlh.setBounds(240, 210, 99, 23);
        jDesktopPane2.add(txtIdlh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel16.setFont(new java.awt.Font("Times New Roman", 0, 14));
        jLabel16.setForeground(new java.awt.Color(0, 0, 255));
        jLabel16.setText("Ten");
        jLabel16.setBounds(140, 250, 71, 17);
        jDesktopPane2.add(jLabel16, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnDellh.setBackground(new java.awt.Color(204, 0, 204));
        btnDellh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        btnDellh.setForeground(new java.awt.Color(0, 0, 204));
        btnDellh.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\delete_icon.png")); // NOI18N
        btnDellh.setText("Xóa");
        btnDellh.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnDellhActionPerformed(evt);
            }
        });
        btnDellh.setBounds(290, 470, 93, 59);
        jDesktopPane2.add(btnDellh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnAddlh.setBackground(new java.awt.Color(0, 255, 0));
        btnAddlh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        btnAddlh.setForeground(new java.awt.Color(255, 0, 0));
        btnAddlh.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\green-plus-sign-small.gif")); // NOI18N
        btnAddlh.setText("Thêm");
        btnAddlh.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnAddlhActionPerformed(evt);
            }
        });
        btnAddlh.setBounds(40, 470, 93, 57);
        jDesktopPane2.add(btnAddlh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnEditlh.setBackground(new java.awt.Color(255, 255, 51));
        btnEditlh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        btnEditlh.setForeground(new java.awt.Color(255, 0, 0));
        btnEditlh.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\icon_refresh.png")); // NOI18N
        btnEditlh.setText("Sửa");
        btnEditlh.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnEditlhActionPerformed(evt);
            }
        });
        btnEditlh.setBounds(160, 470, 93, 60);
        jDesktopPane2.add(btnEditlh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel12.setFont(new java.awt.Font("Times New Roman", 0, 20));
        jLabel12.setForeground(new java.awt.Color(255, 0, 0));
        jLabel12.setText("Loại Sản Phẩm");
        jLabel12.setBounds(170, 110, 140, 73);
        jDesktopPane2.add(jLabel12, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnSearchlh.setBackground(new java.awt.Color(204, 255, 51));
        btnSearchlh.setForeground(new java.awt.Color(0, 0, 255));
        btnSearchlh.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\key.png")); // NOI18N
        btnSearchlh.setText("Tìm tên loại sản phẩm");
        btnSearchlh.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnSearchlhActionPerformed(evt);
            }
        });
        btnSearchlh.setBounds(710, 480, 230, 43);
        jDesktopPane2.add(btnSearchlh, javax.swing.JLayeredPane.DEFAULT_LAYER);
        txtSearchlh.setBounds(520, 490, 140, 30);
        jDesktopPane2.add(txtSearchlh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnLoadlh.setBackground(new java.awt.Color(255, 102, 255));
        btnLoadlh.setForeground(new java.awt.Color(255, 0, 0));
        btnLoadlh.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\iconSchool (4).png")); // NOI18N
        btnLoadlh.setText("Hiện lại danh sách");
        btnLoadlh.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnLoadlhActionPerformed(evt);
            }
        });
        btnLoadlh.setBounds(990, 480, 200, 43);
        jDesktopPane2.add(btnLoadlh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        txttenlh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        txttenlh.setBounds(240, 250, 99, 23);
        jDesktopPane2.add(txttenlh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        tableLoaihang.setFont(new java.awt.Font("Times New Roman", 0, 14));
        tableLoaihang.setForeground(new java.awt.Color(0, 0, 153));
        tableLoaihang.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "Id", "Tên"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.String.class, java.lang.String.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        tableLoaihang.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                tableLoaihangMouseClicked(evt);
            }
        });
        jScrollPane3.setViewportView(tableLoaihang);

        jScrollPane3.setBounds(510, 20, 670, 400);
        jDesktopPane2.add(jScrollPane3, javax.swing.JLayeredPane.DEFAULT_LAYER);

        javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
        jPanel2.setLayout(jPanel2Layout);
        jPanel2Layout.setHorizontalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jDesktopPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 1212, Short.MAX_VALUE)
        );
        jPanel2Layout.setVerticalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jDesktopPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 542, Short.MAX_VALUE)
        );

        jTabbedPane1.addTab("Edit Loại Hàng", new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\iconSchool (4).png"), jPanel2); // NOI18N

        jPanel5.setBackground(new java.awt.Color(153, 255, 255));

        txtIdMh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        txtIdMh.setBounds(240, 190, 99, 23);
        jDesktopPane3.add(txtIdMh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel10.setFont(new java.awt.Font("Times New Roman", 0, 14));
        jLabel10.setForeground(new java.awt.Color(0, 0, 255));
        jLabel10.setText("Số lượng");
        jLabel10.setBounds(140, 310, 71, 17);
        jDesktopPane3.add(jLabel10, javax.swing.JLayeredPane.DEFAULT_LAYER);

        txtTenMh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        txtTenMh.setBounds(240, 230, 99, 23);
        jDesktopPane3.add(txtTenMh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel8.setFont(new java.awt.Font("Times New Roman", 0, 14));
        jLabel8.setForeground(new java.awt.Color(0, 0, 255));
        jLabel8.setText("Ten");
        jLabel8.setBounds(140, 230, 71, 17);
        jDesktopPane3.add(jLabel8, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel9.setFont(new java.awt.Font("Times New Roman", 0, 14));
        jLabel9.setForeground(new java.awt.Color(0, 0, 255));
        jLabel9.setText("Giá tiền");
        jLabel9.setBounds(140, 280, 71, 17);
        jDesktopPane3.add(jLabel9, javax.swing.JLayeredPane.DEFAULT_LAYER);

        txtGiatienMh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        txtGiatienMh.setBounds(240, 270, 99, 23);
        jDesktopPane3.add(txtGiatienMh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnLoadMh.setBackground(new java.awt.Color(255, 153, 204));
        btnLoadMh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        btnLoadMh.setForeground(new java.awt.Color(102, 0, 102));
        btnLoadMh.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\001_44.png")); // NOI18N
        btnLoadMh.setText("Tất cả mặt hàng");
        btnLoadMh.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnLoadMhActionPerformed(evt);
            }
        });
        btnLoadMh.setBounds(1030, 480, 153, 45);
        jDesktopPane3.add(btnLoadMh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnEditMh.setBackground(new java.awt.Color(255, 255, 0));
        btnEditMh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        btnEditMh.setForeground(new java.awt.Color(255, 0, 0));
        btnEditMh.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\icon_refresh.png")); // NOI18N
        btnEditMh.setText("Sửa");
        btnEditMh.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnEditMhActionPerformed(evt);
            }
        });
        btnEditMh.setBounds(190, 480, 130, 48);
        jDesktopPane3.add(btnEditMh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnAddMh.setBackground(new java.awt.Color(51, 255, 0));
        btnAddMh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        btnAddMh.setForeground(new java.awt.Color(255, 0, 0));
        btnAddMh.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\green-plus-sign-small.gif")); // NOI18N
        btnAddMh.setText("Thêm");
        btnAddMh.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnAddMhActionPerformed(evt);
            }
        });
        btnAddMh.setBounds(20, 480, 130, 48);
        jDesktopPane3.add(btnAddMh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        txtSlMh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        txtSlMh.setBounds(240, 310, 99, 23);
        jDesktopPane3.add(txtSlMh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnBackMh.setBackground(new java.awt.Color(0, 255, 204));
        btnBackMh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        btnBackMh.setForeground(new java.awt.Color(255, 0, 51));
        btnBackMh.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\go-back.png")); // NOI18N
        btnBackMh.setText("Quay lại");
        btnBackMh.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnBackMhActionPerformed(evt);
            }
        });
        btnBackMh.setBounds(530, 480, 130, 48);
        jDesktopPane3.add(btnBackMh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel11.setFont(new java.awt.Font("Times New Roman", 0, 14));
        jLabel11.setForeground(new java.awt.Color(0, 0, 255));
        jLabel11.setText("Loại");
        jLabel11.setBounds(140, 150, 71, 17);
        jDesktopPane3.add(jLabel11, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnDelMh.setBackground(new java.awt.Color(204, 0, 204));
        btnDelMh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        btnDelMh.setForeground(new java.awt.Color(0, 0, 204));
        btnDelMh.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\delete_icon.png")); // NOI18N
        btnDelMh.setText("Xóa");
        btnDelMh.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnDelMhActionPerformed(evt);
            }
        });
        btnDelMh.setBounds(360, 480, 130, 48);
        jDesktopPane3.add(btnDelMh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnSearchMh.setBackground(new java.awt.Color(153, 255, 102));
        btnSearchMh.setForeground(new java.awt.Color(0, 0, 153));
        btnSearchMh.setIcon(new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\Update1.png")); // NOI18N
        btnSearchMh.setText("Tìm Kiếm");
        btnSearchMh.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnSearchMhActionPerformed(evt);
            }
        });
        btnSearchMh.setBounds(850, 480, 130, 46);
        jDesktopPane3.add(btnSearchMh, javax.swing.JLayeredPane.DEFAULT_LAYER);
        txtSearchMh.setBounds(700, 490, 100, 30);
        jDesktopPane3.add(txtSearchMh, javax.swing.JLayeredPane.DEFAULT_LAYER);

        tableMh.setFont(new java.awt.Font("Times New Roman", 0, 14));
        tableMh.setForeground(new java.awt.Color(255, 0, 0));
        tableMh.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "Id", "Tên", "Giá tiền", "Số lượng", "Loại"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        tableMh.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                tableMhMouseClicked(evt);
            }
        });
        jScrollPane2.setViewportView(tableMh);

        jScrollPane2.setBounds(470, 20, 560, 400);
        jDesktopPane3.add(jScrollPane2, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel13.setFont(new java.awt.Font("Times New Roman", 0, 20));
        jLabel13.setForeground(new java.awt.Color(0, 0, 255));
        jLabel13.setText("Mặt hàng");
        jLabel13.setBounds(180, 70, 140, 40);
        jDesktopPane3.add(jLabel13, javax.swing.JLayeredPane.DEFAULT_LAYER);

        cmdLoai.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                cmdLoaiMouseClicked(evt);
            }
        });
        cmdLoai.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdLoaiActionPerformed(evt);
            }
        });
        cmdLoai.setBounds(240, 150, 99, 20);
        jDesktopPane3.add(cmdLoai, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel7.setFont(new java.awt.Font("Times New Roman", 0, 14));
        jLabel7.setForeground(new java.awt.Color(0, 0, 255));
        jLabel7.setText("ID");
        jLabel7.setBounds(140, 190, 71, 17);
        jDesktopPane3.add(jLabel7, javax.swing.JLayeredPane.DEFAULT_LAYER);

        javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
        jPanel5.setLayout(jPanel5Layout);
        jPanel5Layout.setHorizontalGroup(
            jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jDesktopPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 1214, Short.MAX_VALUE)
        );
        jPanel5Layout.setVerticalGroup(
            jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jDesktopPane3, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 544, Short.MAX_VALUE)
        );

        javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
        jPanel3.setLayout(jPanel3Layout);
        jPanel3Layout.setHorizontalGroup(
            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 1214, Short.MAX_VALUE)
            .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addComponent(jPanel5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );
        jPanel3Layout.setVerticalGroup(
            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 544, Short.MAX_VALUE)
            .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addComponent(jPanel5, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        jTabbedPane1.addTab("Edit Sản Phẩm", new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\iconSchool (4).png"), jPanel3); // NOI18N

        tableThuchi.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "Number", "Idnv", "Tổng tiền"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.Integer.class, java.lang.String.class, java.lang.String.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        jScrollPane5.setViewportView(tableThuchi);

        jScrollPane5.setBounds(20, 40, 452, 402);
        jDesktopPane4.add(jScrollPane5, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel20.setForeground(new java.awt.Color(255, 255, 255));
        jLabel20.setText("Chức vụ");
        jLabel20.setBounds(620, 40, 70, 20);
        jDesktopPane4.add(jLabel20, javax.swing.JLayeredPane.DEFAULT_LAYER);
        txtChucvu.setBounds(700, 40, 160, 30);
        jDesktopPane4.add(txtChucvu, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel21.setForeground(new java.awt.Color(255, 255, 255));
        jLabel21.setText("Lương");
        jLabel21.setBounds(620, 80, 70, 20);
        jDesktopPane4.add(jLabel21, javax.swing.JLayeredPane.DEFAULT_LAYER);
        txtLuong.setBounds(700, 80, 160, 30);
        jDesktopPane4.add(txtLuong, javax.swing.JLayeredPane.DEFAULT_LAYER);

        tableChucvu.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "Chức vụ", "Mức lương"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.String.class, java.lang.String.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        tableChucvu.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                tableChucvuMouseClicked(evt);
            }
        });
        jScrollPane4.setViewportView(tableChucvu);

        jScrollPane4.setBounds(540, 130, 452, 220);
        jDesktopPane4.add(jScrollPane4, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnDelTl.setText("Xóa");
        btnDelTl.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnDelTlActionPerformed(evt);
            }
        });
        btnDelTl.setBounds(880, 400, 90, 50);
        jDesktopPane4.add(btnDelTl, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnEditTl.setText("Sửa");
        btnEditTl.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnEditTlActionPerformed(evt);
            }
        });
        btnEditTl.setBounds(720, 400, 90, 50);
        jDesktopPane4.add(btnEditTl, javax.swing.JLayeredPane.DEFAULT_LAYER);

        btnAddTl.setText("Thêm");
        btnAddTl.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnAddTlActionPerformed(evt);
            }
        });
        btnAddTl.setBounds(560, 400, 90, 50);
        jDesktopPane4.add(btnAddTl, javax.swing.JLayeredPane.DEFAULT_LAYER);

        javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
        jPanel4.setLayout(jPanel4Layout);
        jPanel4Layout.setHorizontalGroup(
            jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jDesktopPane4, javax.swing.GroupLayout.DEFAULT_SIZE, 1214, Short.MAX_VALUE)
        );
        jPanel4Layout.setVerticalGroup(
            jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jDesktopPane4, javax.swing.GroupLayout.DEFAULT_SIZE, 544, Short.MAX_VALUE)
        );

        jTabbedPane1.addTab("Thu chi", new javax.swing.ImageIcon("C:\\Users\\Huy\\Desktop\\Hoc\\icon\\add booth.png"), jPanel4); // NOI18N

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jTabbedPane1)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 606, javax.swing.GroupLayout.PREFERRED_SIZE)
        );

        pack();
    }// </editor-fold>//GEN-END:initComponents

private void btnAddTlActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnAddTlActionPerformed
this.addcv();
}//GEN-LAST:event_btnAddTlActionPerformed

private void btnEditTlActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnEditTlActionPerformed
this.upadtetl();
}//GEN-LAST:event_btnEditTlActionPerformed

private void btnDelTlActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnDelTlActionPerformed
this.deletetl();
}//GEN-LAST:event_btnDelTlActionPerformed

private void tableChucvuMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_tableChucvuMouseClicked
    int idongdachon = tableChucvu.getSelectedRow();
    if (idongdachon != -1) {
        txtChucvu.setText(String.valueOf(tableChucvu.getValueAt(idongdachon, 0)));
        txtLuong.setText(String.valueOf(tableChucvu.getValueAt(idongdachon, 1)));
    }
}//GEN-LAST:event_tableChucvuMouseClicked

private void cmdLoaiActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdLoaiActionPerformed
}//GEN-LAST:event_cmdLoaiActionPerformed

private void cmdLoaiMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_cmdLoaiMouseClicked
}//GEN-LAST:event_cmdLoaiMouseClicked

private void tableMhMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_tableMhMouseClicked
    int idongdachon = tableMh.getSelectedRow();
    if (idongdachon != -1) {
        txtIdMh.setText(String.valueOf(tableMh.getValueAt(idongdachon, 0)));
        txtTenMh.setText(String.valueOf(tableMh.getValueAt(idongdachon, 1)));
        txtGiatienMh.setText(String.valueOf(tableMh.getValueAt(idongdachon, 2)));
        txtSlMh.setText(String.valueOf(tableMh.getValueAt(idongdachon, 3)));
        cmdLoai.setSelectedItem(String.valueOf(tableMh.getValueAt(idongdachon, 4)));
    }
}//GEN-LAST:event_tableMhMouseClicked

private void btnSearchMhActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnSearchMhActionPerformed
    this.seachsp();
}//GEN-LAST:event_btnSearchMhActionPerformed

private void btnDelMhActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnDelMhActionPerformed
    this.deletesp();
}//GEN-LAST:event_btnDelMhActionPerformed

private void btnBackMhActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnBackMhActionPerformed
    String nick = null;
    String pwd = null;
    Menuchinh g = new Menuchinh(nick, pwd);
    g.setVisible(true);
    this.dispose();
}//GEN-LAST:event_btnBackMhActionPerformed

private void btnAddMhActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnAddMhActionPerformed
    this.addsp();
}//GEN-LAST:event_btnAddMhActionPerformed

private void btnEditMhActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnEditMhActionPerformed
    this.upadtesp();
}//GEN-LAST:event_btnEditMhActionPerformed

private void btnLoadMhActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnLoadMhActionPerformed
    this.displaysp();
}//GEN-LAST:event_btnLoadMhActionPerformed

private void tableLoaihangMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_tableLoaihangMouseClicked
    int idongdachon = tableLoaihang.getSelectedRow();
    if (idongdachon != -1) {
        txtIdlh.setText(String.valueOf(tableLoaihang.getValueAt(idongdachon, 0)));
        txttenlh.setText(String.valueOf(tableLoaihang.getValueAt(idongdachon, 1)));
    }
}//GEN-LAST:event_tableLoaihangMouseClicked

private void btnLoadlhActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnLoadlhActionPerformed
    this.displaylsp();
}//GEN-LAST:event_btnLoadlhActionPerformed

private void btnSearchlhActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnSearchlhActionPerformed
    if (txtSearchlh.getText().compareTo("") == 0) {
        JOptionPane.showMessageDialog(rootPane, "Vui lòng nhập thông tin tìm kiếm");
    } else {
        this.seachlsp();
        int i = tableLoaihang.getRowCount();
        if (i == 0) {
            JOptionPane.showMessageDialog(rootPane, "Không tìm thấy thông tin cần tìm kiếm");
        }
    }
}//GEN-LAST:event_btnSearchlhActionPerformed

private void btnEditlhActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnEditlhActionPerformed
    this.upadtelsp();
}//GEN-LAST:event_btnEditlhActionPerformed

private void btnAddlhActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnAddlhActionPerformed
    this.addlsp();
}//GEN-LAST:event_btnAddlhActionPerformed

private void btnDellhActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnDellhActionPerformed
    this.deletelsp();
}//GEN-LAST:event_btnDellhActionPerformed

private void btnInnvActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnInnvActionPerformed
//      try{
//    String source ="src\\Report\\reportNhanvien.jrxml";
//    JasperReport jr=JasperCompileManager.compileReport(source);
//    Connection conn=DAOUtil.getConnection();
//   // Map<Object, Double> params=new HashMap<Object,Double>();
//    Map<String,String> params=new HashMap<String,String>();
//    //params.put("a",a);
//    JasperPrint jp=JasperFillManager.fillReport(jr, params, conn);
//    JasperViewer.viewReport(jp, false);
//    }catch(Exception e){
//        System.out.print(e.getMessage());
//    }
}//GEN-LAST:event_btnInnvActionPerformed

private void btnSearchnvActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnSearchnvActionPerformed
    if (txtSearchnv.getText().compareTo("") == 0) {
        JOptionPane.showMessageDialog(rootPane, "Vui lòng nhập thông tin tìm kiếm");
    } else {
        this.seach1();
        int i = tableNhanvien.getRowCount();
        if (i == 0) {
            JOptionPane.showMessageDialog(rootPane, "Không tìm thấy thông tin cần tìm kiếm");
        }
    }
}//GEN-LAST:event_btnSearchnvActionPerformed

private void btnAddnvActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnAddnvActionPerformed
    this.add1();
}//GEN-LAST:event_btnAddnvActionPerformed

private void btnLoadnvActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnLoadnvActionPerformed
    this.display1();
}//GEN-LAST:event_btnLoadnvActionPerformed

private void btnBacknvActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnBacknvActionPerformed
    String nick = null;
    String pwd = null;
    Menuchinh g = new Menuchinh(nick, pwd);
    g.setVisible(true);
    this.dispose();
}//GEN-LAST:event_btnBacknvActionPerformed

private void btnEditnvActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnEditnvActionPerformed
    this.upadte1();
}//GEN-LAST:event_btnEditnvActionPerformed

private void btnDelnvActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnDelnvActionPerformed
    this.delete1();
}//GEN-LAST:event_btnDelnvActionPerformed

private void tableNhanvienMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_tableNhanvienMouseClicked
    int idongdachon = tableNhanvien.getSelectedRow();
    if (idongdachon != -1) {
        txtIdnv.setText(String.valueOf(tableNhanvien.getValueAt(idongdachon, 0)));
        txtTennv.setText(String.valueOf(tableNhanvien.getValueAt(idongdachon, 1)));
        txtDiachinv.setText(String.valueOf(tableNhanvien.getValueAt(idongdachon, 2)));
        txtSdtnv.setText(String.valueOf(tableNhanvien.getValueAt(idongdachon, 3)));
        txtMknv.setText(String.valueOf(tableNhanvien.getValueAt(idongdachon, 4)));
        txtChucvunv.setText(String.valueOf(tableNhanvien.getValueAt(idongdachon, 5)));
        Date today = new Date(tableNhanvien.getValueAt(idongdachon, 6).toString());
        DateNgayvaonv.setDate(today);
    }
}//GEN-LAST:event_tableNhanvienMouseClicked

    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        /* Set the Nimbus look and feel */
        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(Admin1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(Admin1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(Admin1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(Admin1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>

        /* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {
                new Admin1(null, null).setVisible(true);
            }
        });
    }
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private com.toedter.calendar.JDateChooser DateNgayvaonv;
    private javax.swing.JButton btnAddMh;
    private javax.swing.JButton btnAddTl;
    private javax.swing.JButton btnAddlh;
    private javax.swing.JButton btnAddnv;
    private javax.swing.JButton btnBackMh;
    private javax.swing.JButton btnBacknv;
    private javax.swing.JButton btnDelMh;
    private javax.swing.JButton btnDelTl;
    private javax.swing.JButton btnDellh;
    private javax.swing.JButton btnDelnv;
    private javax.swing.JButton btnEditMh;
    private javax.swing.JButton btnEditTl;
    private javax.swing.JButton btnEditlh;
    private javax.swing.JButton btnEditnv;
    private javax.swing.JButton btnInnv;
    private javax.swing.JButton btnLoadMh;
    private javax.swing.JButton btnLoadlh;
    private javax.swing.JButton btnLoadnv;
    private javax.swing.JButton btnSearchMh;
    private javax.swing.JButton btnSearchlh;
    private javax.swing.JButton btnSearchnv;
    private javax.swing.JComboBox cmdLoai;
    private javax.swing.JDesktopPane jDesktopPane1;
    private javax.swing.JDesktopPane jDesktopPane2;
    private javax.swing.JDesktopPane jDesktopPane3;
    private javax.swing.JDesktopPane jDesktopPane4;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel17;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel20;
    private javax.swing.JLabel jLabel21;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JPanel jPanel4;
    private javax.swing.JPanel jPanel5;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JScrollPane jScrollPane4;
    private javax.swing.JScrollPane jScrollPane5;
    private javax.swing.JTabbedPane jTabbedPane1;
    private javax.swing.JTable tableChucvu;
    private javax.swing.JTable tableLoaihang;
    private javax.swing.JTable tableMh;
    private javax.swing.JTable tableNhanvien;
    private javax.swing.JTable tableThuchi;
    private javax.swing.JTextField txtChucvu;
    private javax.swing.JTextField txtChucvunv;
    private javax.swing.JTextField txtDiachinv;
    private javax.swing.JTextField txtGiatienMh;
    private javax.swing.JTextField txtIdMh;
    private javax.swing.JTextField txtIdlh;
    private javax.swing.JTextField txtIdnv;
    private javax.swing.JTextField txtLuong;
    private javax.swing.JTextField txtMknv;
    private javax.swing.JTextField txtSdtnv;
    private javax.swing.JTextField txtSearchMh;
    private javax.swing.JTextField txtSearchlh;
    private javax.swing.JTextField txtSearchnv;
    private javax.swing.JTextField txtSlMh;
    private javax.swing.JTextField txtTenMh;
    private javax.swing.JTextField txtTennv;
    private javax.swing.JTextField txttenlh;
    // End of variables declaration//GEN-END:variables
}
